package com.aring.service;

import java.util.ArrayList;
import java.util.Map;

import com.aring.bean.MatchInfo;
import com.aring.bean.Place;
import com.aring.bean.PlaceManager;
import com.aring.bean.School;
import com.aring.bean.TimeTable;

public interface PlaceManagerService {
	//添加管理者
	public int addPlaceManager(PlaceManager placeManager);
	//根据管理者登陆账号查询是否存在和密码
	public PlaceManager selectPlaceManagerByAccount(String Account);
    //赛事信息插入
	public int insertMatchInfo(MatchInfo mi);
	//根据pm_no查询
	public PlaceManager selectPlaceManagerByPm_no(Integer pm_no);
	//根据pm_no更新
	public int updateManager(PlaceManager manager);
	//根据pm_no查询相关发布的赛事
	public ArrayList<PlaceManager> selectMatchInfo(Integer pm_no);
	//根据mi_no查询赛事
	public MatchInfo selectMatchByMi_no(Integer match_no);
	//更新赛事信息
	public int updateMatch(MatchInfo match);
	//发布场馆
	public int insertPlace(Place place);
	//查找场馆
	public Place selectPlaceByP_no(Integer p_no);
	//根据管理员编号查找场馆
	public ArrayList<Place> selectPlaceByPm_no(Integer pm_no);
	//更新场馆信息
	public int updatePlace(Place place);
	//根据管理员id查询学校
	public ArrayList<School> querySchool(Integer pm_no);
	//根据管理员id和学校id查询类型
	public ArrayList queryType(Integer pm_no, Integer school);
	//根据学校id查找学校
	public School querySchoolById(Integer id);
	//根据学校名字和类型查找场馆id
	public Integer queryP_noBySchoolAndType(String name,String type);
	//插入场次
	public int insertPlaceNum(Integer p_no, Integer pn_no);
	public Integer queryPn_id(Integer p_no, Integer pn_no);
	public int insertTimeTable(TimeTable table);
}
